پیش نیازها:
- این دوره در اکسل 2019 ثبت شده اما کلیه نسخه های قبلی 2007،2010،2013،2016 و office 365 در این دوره کار می کنند
- دانلود رایگان Microsoft Power BI
- این دوره برای چه کسی است؟
- هر کسی بخواهد از مقدماتی تا پیشرفته بیاموزد ، این دوره مباحث مربوط به مقدماتی را شامل می شود
- هر شخصی می خواهد هوش تجاری را برای تجزیه و تحلیل داده ها و ایجاد داشبورد و گزارش ها بیاموزد ، قدرت مایکروسافت BI را از سطح پایه تا بالاترین سطح یاد بگیرد

در ادامه با برخی از سرفصل های درسی این مجموعه آموزش آشنا می شویم :
Data Analysis in PivotTables (Creating Revenue Dashboard)
Sparklines (Line,Column,Win or Loss) and Data Bars
Waterfall Chart,Funnel Chart and Map Chart
People Graph,Sunburst Chart,Treemap and Bubble Charts
Stocks and Geography,Progress Chart
Analyzing Sales Data in Pivot Tables and Pivot Charts
Creating Excel Tables,PivotTables and PivotCharts
Data Validation and Inserting Comments
Analyzing Data in the Table
Analyzing Data with PivotTables
Analyzing Data with Business Intelligence (Power Queries and Trendlines)
Analyzing Data with Business Intelligence (Forecast Sheet)
Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)
Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)
Loading Website Data into Power Map(Power Query,Power Map)
Extracting Data from the Website(Power Query,Pivot Table)
Extracting Football Team Data from the Website(Power Query,Pivot Table)
Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)
Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)
Analyzing Business Data with Solver
Introduction to Excel
Calculations With Basic Formulas
Calculations with Simple Excel Functions
Formatting a Worksheet
Saving and Printing a Workbook
Project Calculations with Operators and Functions
IF and VLOOKUP Functions
Adding Column and Pie Charts in an Excel worksheet
Date and Time Functions in an Excel
Logical Functions in an Excel
Lookup and Reference Functions in an Excel
Adding Line and Combination Charts in an Excel
Text Functions in an Excel
Math and Trigonometry Functions in an Excel
Statistical Functions in an Excel
Engineering Functions in an Excel
Information Functions in an Excel
Database Functions in an Excel
Financial Functions:Borrow Money to Bank
Financial Functions:Invest Money in the Bank Saving Account
Financial Functioms:Build Future Income Statement of Company
Financial Functions:Calculate Depreciation of an Asset of Company
Financial Functions:Invest Money in Company
Basic Financial Examples(Learn Use of Operators ,-,/,*)
Microsoft Power BI
Microsoft Power BI:Create Global Store Sales Dashboard
Microsoft Power BI:Create Malaria Analytics Dashboard
Microsoft Power BI:Create Climate Change Report
Bookmarks Pane and Selection Pane
Editing and Visualizing Data
Extracting Data from the Website
Extracting Sales Data from the Website
Publish and Create Dashboard
New Quick Measure(Calculations Without Dax)
Custom Visuals