Excel Power BI for PRO-end user |
|---|
| Course Outline |
Outline
|
| PowerPoint Slides |
Intro.pptx
|
| Day | Modules | Sharing |
|---|
| 1 |
- More M Function
- Create Auto Rolling Calendar
- Understanding all types of relationship between table to table one to one, one to many, many to many, many to one
- Creating active and inactive relationships
- Filter fow in relationship (single and bidirection)
- Nesting CALCULATE()
- Date Intelligent
- Color and indicators
- Advanced interactive tools
|
|
| 2 |
- Getting the AI visual into your report
- Key Infuencers
- Administer an app workspace
- Collaborate
- App
- Confguring Data Gateways
- Create a OneN True Source of Sata Source
|
|
| Recommanded Books |
|---|
 | Title | Supercharge Power BI: Power BI Is Better When You Learn to Write DAX |
|---|
| ISBN | 978-1-615-47069-3 |
|---|
| Author | Matt Allington |
|---|
| Year | 2018 |
|---|
| Publisher | Holy Macro! Books |
|---|
 | Title | Power BI: Moving Beyond the Basics of Power BI and Learning about DAX Language |
|---|
| ISBN | B089XYQCVR |
|---|
| Author | Mike Morris, Nick Gallagher, et al. |
|---|
| Year | 2020 |
|---|
| Publisher | Albano Publishing LLC |
|---|
 | Title | DAX Cookbook: Over 120 recipes to enhance your business with analytics, reporting, and business intelligence |
|---|
| ISBN | 978-1-839-21707-4 |
|---|
| Author | Greg Deckler |
|---|
| Year | 2020 |
|---|
| Publisher | Packt Publishing |
|---|
 | Title | Hands-On Business Intelligence with DAX |
|---|
| ISBN | 978-1-838-82863-9 |
|---|
| Author | Ian Horne |
|---|
| Year | 2020 |
|---|
| Publisher | Packt |
|---|
 | Title | Applied DAX with Power BI: From zero to hero with 15-minute lessons |
|---|
| ISBN | 978-1-733-04610-7 |
|---|
| Author | Lachev, Teo |
|---|
| Year | 2019 |
|---|
| Publisher | Prologika Press |
|---|
 | Title | DAX Patterns |
|---|
| ISBN | 978-1-735-36520-6 |
|---|
| Author | Russo, Marco; Ferrari, Alberto |
|---|
| Year | 2020 |
|---|
| Publisher | SQLBI Corp. |
|---|
 | Title | Supercharge Excel: When you learn to Write DAX for Power Pivot |
|---|
| ISBN | 978-1-615-47053-2 |
|---|
| Author | Matt Allington |
|---|
| Year | 2018 |
|---|
| Publisher | Holy Macro! Books |
|---|
 | Title | Pro DAX with Power BI: Business Intelligence with Powerpivot and SQL Server Analysis Services Tabular |
|---|
| ISBN | 978-1-484-24896-6 |
|---|
| Author | Philip Seamark; Tom Martens |
|---|
| Year | 2019 |
|---|
| Publisher | Apress |
|---|
 | Title | Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence |
|---|
| ISBN | 978-1-484-23476-1 |
|---|
| Author | Philip Seamark |
|---|
| Year | 2018 |
|---|
| Publisher | Apress |
|---|
 | Title | Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources |
|---|
| ISBN | 978-1-484-26017-3 |
|---|
| Author | Adam Aspin |
|---|
| Year | 2020 |
|---|
| Publisher | Apress |
|---|
 Monkey.jpg) | Title | M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query |
|---|
| ISBN | 978-1-615-47034-1 |
|---|
| Author | Ken Puls, Miguel Escobar |
|---|
| Year | 2015 |
|---|
| Publisher | Ken Puls, Miguel Escobar |
|---|
 | Title | Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow Second edition |
|---|
| ISBN | 978-1-615-47358-8 |
|---|
| Author | Ken Puls, Miguel Escobar |
|---|
| Year | 2021 |
|---|
| Publisher | Ken Puls, Miguel Escobar |
|---|
.jpg) | Title | Collect, Transform and Combine Data using Power BI and Power Query in Excel (Business Skills) |
|---|
| ISBN | 978-1-509-30795-1 |
|---|
| Author | Gil Raviv |
|---|
| Year | 2018 |
|---|
| Publisher | Microsoft Press |
|---|
 | Title | Analyzing Data with Power BI and Power Pivot for Excel |
|---|
| ISBN | 978-1-509-30276-5 |
|---|
| Author | Alberto Ferrari, Marco Russo |
|---|
| Year | 2017 |
|---|
| Publisher | Microsoft Press |
|---|