Bi Analyst Tools: (Excel, Vba, Sql, Power Query, Power Bi)
Published 6/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.77 GB | Duration: 14h 54m
Published 6/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.77 GB | Duration: 14h 54m
Mastering Data Visualization and Analytics with BI Tools: (Excel, VBA, SQL, Power Query, DAX, Macros, Power BI)
What you'll learn
Understanding the importance and role of data analysis in a business context.
Familiarity with key tools in data analysis, including Power BI, SQL, Excel, and DAX.
Ability to connect Power BI to various data sources.
Skills to clean and transform raw data for analysis using Power Query in Power BI.
Proficiency in writing SQL queries for data extraction and manipulation.
Developing and working with databases in SQL, including concepts such as Joins, Views, and Stored Procedures.
Understanding how to use Excel for data analysis, including sorting, filtering, and use of formulas and functions.
Advanced Excel skills such as data validation and what-if analysis.
Mastery of PivotTables and PivotCharts in Excel.
Understanding the basics of DAX, including its syntax and various functions.
Ability to create calculated columns and measures using DAX.
Mastering advanced DAX concepts like Time Intelligence functions.
Creating relational data models in Power BI.
Designing interactive visuals in Power BI, including charts, graphs, and tables.
Understanding the principles of good dashboard design.
Creating effective, business-oriented dashboards in Power BI.
Ability to tell compelling stories with data.
Ability to tell compelling stories with data.
Hands-on experience of building a business-oriented dashboard in a Capstone Project.
Confidence and competence to use Power BI, SQL, Excel, and DAX in real-world business scenarios for data analysis and visualization.
Requirements
While this course starts with the basics, a general understanding of computers and software is required. No prior knowledge of Power BI, SQL, Excel, or DAX is needed. A willingness to learn and an interest in data analysis are the main prerequisites.
Description
Welcome to " BI Analyst Tools: Unleashing Business Intelligence," an immersive course designed to guide you through the world of data analysis using state-of-the-art tools such as Power BI, SQL, Excel, and DAX. Whether you're a novice just starting your journey, or an established professional seeking to enhance your toolkit, this course offers an expansive insight into the realm of data analysis, visualization, and business intelligence.Today, the business landscape is becoming increasingly data-driven. Every business decision is underpinned by data, insights, and analytics. Recognizing this shift, our course intends to impart the skills necessary to navigate, analyze, and interpret complex data, allowing you to harness its power and drive strategic decision-making.The course kicks off with a fundamental understanding of data analysis, its role, and significance in business. As we progress, we'll delve into the basics of Power BI, SQL, Excel, and DAX, essential tools for any data analyst. You'll learn how to gather, clean, and transform data, preparing it for insightful analysis.As we dive deeper, we'll explore DAX, a library of functions and operators that provide the muscle for crunching numerical data. We'll then move on to one of the most exciting aspects of data analysis: visualizations. You'll learn how to design and implement interactive charts, graphs, and other visuals, and arrange them in a compelling dashboard that tells the story hidden within your data.Excel, a classic tool with robust capabilities, plays an essential role in our course. We'll navigate its features, from basic functions to pivot tables, exploring how it can be employed in data analysis. With SQL, we'll show you how to query databases to retrieve and manipulate data, essential skills for working with large datasets.Perhaps one of the most rewarding parts of this course is the Capstone Project. You'll apply the skills you've learned to create a business-oriented dashboard, incorporating elements from Power BI, SQL, Excel, and DAX. This hands-on experience is designed to solidify your learning and provide a taste of real-world data analysis projects.This course is for anyone with a desire to understand data and draw insights from it. No prior knowledge of Power BI, SQL, Excel, or DAX is required—only a willingness to learn and a fascination with data. The course is ideal for beginners interested in data analysis, professionals seeking to enhance their data analysis skills, business professionals, and students in business or data science disciplines.In conclusion, " BI Analyst Tools: Unleashing Business Intelligence" is more than just a course—it's your gateway to the intriguing world of data analysis. Upon completion, you'll not only understand how to use Power BI, SQL, Excel, and DAX, but you'll also know how to weave them together to create captivating dashboards that make data speak. Embark on this journey with us and discover the transformative power of data analysis and business intelligence.
Overview
Section 1: Introduction to Data Analysis
Lecture 1 Introduction
Lecture 2 Introduction to Data Analysis
Lecture 3 Overview of Data Analysis
Lecture 4 Roles in Data
Lecture 5 Role and importance of data analysis in business
Lecture 6 Task of a Data Analyst
Lecture 7 Overview of data analysis tools
Lecture 8 Introduction to Power BI, SQL, and Excel
Lecture 9 Comparisons between Power BI, SQL, and Excel
Lecture 10 Introduction to DAX
Lecture 11 Introduction to Dashboards
Lecture 12 What is a dashboard and its importance
Lecture 13 Components of a dashboard
Section 2: MySQL Database Server Setup
Lecture 14 What is MySQL
Lecture 15 MySQL Installation on Windows
Lecture 16 MySQL Installation on Mac
Lecture 17 Introduction to MySQL Workbench
Lecture 18 Installing MySQL Workbench on Macs
Lecture 19 Basic Database Concepts
Lecture 20 What is a Schema
Lecture 21 Database Schema
Lecture 22 MySQL Data Types
Section 3: Basics of SQL
Lecture 23 Introduction to SQL
Lecture 24 SQL Syntax
Lecture 25 Data Definition Language (DDL)
Lecture 26 CREATE Database Statement
Lecture 27 CREATE Table Statement
Lecture 28 INSERT INTO Statement
Lecture 29 SELECT Statement
Lecture 30 UPDATE Statement
Lecture 31 DELETE Statement
Lecture 32 Intermediate SQL
Lecture 33 SQL Indexes
Lecture 34 Introduction to Table Joins
Lecture 35 INNER Join
Lecture 36 LEFT Join
Lecture 37 RIGHT Join
Lecture 38 SELF Join
Lecture 39 Introduction to Views
Lecture 40 Creating Views
Lecture 41 Querying Views
Lecture 42 Modifying Views
Lecture 43 Dropping Views
Lecture 44 Introduction to Sub queries
Lecture 45 Nested Sub queries
Lecture 46 Grouping Rows of data using GROUP BY CLAUSE
Lecture 47 Filtering groups using HAVING CLAUSE
Lecture 48 Sorting data using ORDER BY Clause
Lecture 49 Filtering rows of data using WHERE Clause
Lecture 50 Introduction to Aggregate Functions
Lecture 51 AVG Function
Lecture 52 COUNT Function
Lecture 53 SUM Function
Lecture 54 MIN Function
Lecture 55 MAX Function
Lecture 56 What are stored procedures
Lecture 57 Creating stored procedure
Lecture 58 Modifying stored procedure
Lecture 59 Creating an advanced stored procedure
Lecture 60 Calling and deleting stored procedures
Lecture 61 Stored procedures and functions
Lecture 62 SQL for Data Analysis
Section 4: Data Analysis with Excel
Lecture 63 Basic Excel for Data Analysis
Lecture 64 Opening a new workbook
Lecture 65 Basic data entry in excel
Lecture 66 Data entry with autofil
Lecture 67 Data entry with date
Lecture 68 Data entry with time
Lecture 69 Undo and redo changes
Lecture 70 Adding comments
Lecture 71 Giving worksheet a title
Lecture 72 Saving your work
Lecture 73 Introduction to Functions and Formulas
Lecture 74 Using formulas for arithmetic tasks
Lecture 75 Re-using Formulas
Lecture 76 Calculating YTD Profits
Lecture 77 Calculating Percentage Change
Lecture 78 Relative and Absolute Reference
Lecture 79 Using RANK Function
Lecture 80 STD Function
Lecture 81 Small and Large Functions
Lecture 82 Median Function
Lecture 83 Count and counta functions
Lecture 84 What is Power Query
Lecture 85 Connecting to a data source
Lecture 86 PLEASE READ
Lecture 87 Preparing your query
Lecture 88 Cleansing data
Lecture 89 Enhancing query
Lecture 90 What is Power Pivot
Lecture 91 Creating a data model
Lecture 92 Importing data and creating relationships
Lecture 93 Create lookups with DAX
Lecture 94 Analyze data with Pivot Tables
Lecture 95 Analyze data with Pivot Charts
Lecture 96 Refreshing Source Data
Lecture 97 Updating Queries
Lecture 98 Creating new reports
Lecture 99 Data sorting and filtering
Lecture 100 Formulas and functions
Lecture 101 PivotTables and PivotCharts
Lecture 102 Intermediate Excel for Data Analysis
Lecture 103 Conditional formatting
Lecture 104 Lookup & Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
Lecture 105 Advanced Excel for Data Analysis
Lecture 106 Data validation
Lecture 107 What-If Analysis
Section 5: Introduction to Macros
Lecture 108 Introduction to macros
Lecture 109 What are Macros
Lecture 110 What is VBA
Lecture 111 Activating Macros and VBA Tools
Lecture 112 Exploring VBA Tools
Lecture 113 Creating a basic Macro
Lecture 114 Saving a worksheet with a macro
Lecture 115 Creating a another macro: Part 1
Lecture 116 Creating a another macro: Part 2
Lecture 117 Exploring Macros with VBA Editor
Lecture 118 Commenting and deleting macro code
Lecture 119 Editing Macros
Lecture 120 Sorting data with Macros
Lecture 121 Filtering Data with Macros
Lecture 122 Creating buttons to run Macros
Lecture 123 Protecting cells and sheets with Macros
Lecture 124 Debugging Macros: Part 1
Lecture 125 Debugging Macros: Part 2
Lecture 126 Debugging Macros: Part 3
Lecture 127 Manually Create Macros
Section 6: Introduction to Power BI and DAX
Lecture 128 What is Power BI
Lecture 129 What is Power BI Desktop
Lecture 130 Installing Power BI Desktop
Lecture 131 Exploring Power BI Desktop Interface
Lecture 132 Microsoft 365 Setup
Lecture 133 Getting Started with Microsoft 365
Lecture 134 Creating a new user account in Microsoft 365
Lecture 135 Connecting to data sources
Lecture 136 Power BI Overview - Part 1
Lecture 137 Power BI Overview - Part 2
Lecture 138 Power BI Overview - Part 3
Lecture 139 Components of Power BI
Lecture 140 Building blocks of Power BI
Lecture 141 Exploring Power BI Service
Lecture 142 Connecting to online data
Lecture 143 Clean and transform data - part 1
Lecture 144 Clean and transform data - part 2
Lecture 145 Combine data sources
Lecture 146 Power BI Visualizations
Lecture 147 Creating charts, graphs, and tables
Lecture 148 Interactive visuals
Lecture 149 Visualizing data - Part 1
Lecture 150 Visualizing data - Part 2
Lecture 151 Publishing report to Power BI Service
Lecture 152 Connecting to Microsoft Access Data Source
Lecture 153 Power Query Editor
Lecture 154 Creating and managing Query Groups
Lecture 155 Renaming Queries
Lecture 156 Splitting Columns
Lecture 157 Changing data types
Lecture 158 Removing and reordering columns
Lecture 159 Creating conditional columns
Lecture 160 Connecting to files in folder
Lecture 161 Appending queries
Lecture 162 Merging Queries
Lecture 163 Query dependency view
Lecture 164 Power BI Transformations
Lecture 165 Data cleaning and transformations
Lecture 166 Transforming less structured data
Lecture 167 Creating tables
Lecture 168 Query Parameters
Lecture 169 Data Modelling
Lecture 170 Data Modeling in Power BI
Lecture 171 Relationships in Power BI
Lecture 172 Creating and managing data relationships
Lecture 173 Creating calculated columns
Lecture 174 Optimizing models for reporting
Lecture 175 Applying Filters to Visualizations
Lecture 176 Time Intelligence
Lecture 177 Time intelligence functions
Lecture 178 Introduction to DAX
Lecture 179 Basic DAX functions and syntax
Lecture 180 DAX measures and calculated columns
Lecture 181 Advanced DAX
Lecture 182 Filter and value DAX functions
Lecture 183 Star Schema and Snowflake Schema
Section 7: 6: Dashboards and Data Storytelling
Lecture 184 Designing Dashboards in Power BI
Lecture 185 Principles of good dashboard design
Lecture 186 Power BI Dashboard vs Power BI Report
Lecture 187 Data Storytelling
Lecture 188 Importance of storytelling in data analysis
Lecture 189 Techniques for effective data storytelling
Lecture 190 Project: Build Your Own Dashboard
Lecture 191 Build a business-oriented dashboard using learned tools
Section 8: Example Captone Project using the tools
Lecture 192 Example Project
Beginners interested in learning data analysis and business intelligence tools.,Professionals who want to enhance their data analysis skills.,Data analysts aiming to learn new tools and techniques.,Data analysts aiming to learn new tools and techniques.,Students in the fields of business, data science, or related disciplines looking to augment their skills.