English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 45 Lessons (7h 41m) | 1.28 GB
The only course you need to launch your career as a Data Professional! Learn to master Excel’s built-in power tools, including Power Query, Power Pivot Tables, Data Modeling, the DAX formula language, and so much more. Become a Business Intelligence Analyst and get hired in 2022.
We guarantee you that this is the best and most up-to-date Excel for Business Intelligence Bootcamp that you can find. You will learn to conduct professional, compelling analyses with Excel using the advanced ‘power’ tools built-in to Excel including Power Query, Power Pivot Tables, and the DAX formula language. You’ll even build an end-to-end Business Intelligence solution for a fictional Surf Shop where you’ll create dozens of powerful KPIs that provide deep insight into business performance. By the end, you’ll have the skills to get hired as a Business Intelligence Analyst in 2022!
WHAT YOU’LL LEARN
- Become a top 10% Business Intelligence Analyst to enhance your skillset and career opportunities
- Build an end-to-end Business Intelligence solution for a fictional surf shop, including dozens of powerful KPIs that provide deep insight into business performance
- Use Power Query to pull external datasets into Excel, and transform them into whatever shape is needed for data analysis
- Master the art and science of Data Modeling in Excel, connecting relational datasets from Power Query so they can be analyzed together
- Build ‘Power’ Pivot Tables to rapidly extract insights from the Excel Data Model, whether your data tables have 10 rows or 10 million
- Proficiently apply the DAX formula language, to inject sophisticated calculations and KPIs into Pivot Tables
- Polish calculations into professional presentations, with data visualization tools like Pivot Charts and conditional formatting
- Use Excel’s powerful charting engine to tell the story of your data with attractive data visualizations
- Learn how to build Excel formulas for data analysis, data science, data entry, and everyday office use
- Leverage Slicers and Timelines to engineer dynamic dashboards that maximize the amount of information you can present on a single screen
- Learn how to use Microsoft Excel to supplement your Power BI skills
- Loads of exercises to practice and perfect your skills
- Learn why Excel is one of the most popular pieces of software across all industries
- Master Excel’s built-in ‘power’ tools and see how they’re nearly identical to those found in Microsoft’s flagship Business Intelligence tool, Power BI
Table of Contents
01 Business Intelligence with Excel
02 Introducing Power Query
03 Applying Basic Transformations
04 Editing Transformations
05 Numerical Transformations
06 Text Transformations
07 Date Transformations – Building a Calendar Table
08 Conditional Transformations
09 Merging Datasets
10 Appending Datasets
11 Introducing Excel’s Data Model
12 Putting the Data Model to Work
13 Relationships
14 Relationships in The Excel Data Model
15 Power Pivot Tables
16 Calendar Tables
17 Exercise: Imposter Syndrome
18 Power Pivot Pitfalls
19 Multiple Data Tables
20 Calculated Columns With DAX
21 The IF Function in DAX
22 The SWITCH Function
23 The RELATED Function
24 Introducing Measures
25 Using DAX Functions in Measures
26 The CALCULATE Function
27 The ALL Function
28 Introducing Time Intelligence Functions
29 The ISBLANK Function
30 The DATEADD Function
31 The DATESINPERIOD Function
32 Variables in DAX
33 The X Functions
34 The RANKX Function
35 The TOPN Function
36 Pivot Table Formatting Tips
37 Conditional Formating: Data Bars, Color Scales, and Icon Sets
38 Custom Conditional Formats
39 Introducing Pivot Charts
40 Column Charts
41 Line Charts, Area Charts, and Timelines
42 Combo Charts
43 Changing Measures With Slicers
44 Using Pivot Tables as Formulas
45 Thank You!
Resolve the captcha to access the links!