Excel Data Analysis Basics EDAB EDAB01 Introduction to Class What is Data Analysis Instructor Scope of Class Version of Excel Define Data Analysis amp Business Intelligence Goals of Class ID: 1031084
Download Presentation The PPT/PDF document "Data Analysis & Business Intelligenc..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
1. Data Analysis & Business Intelligence Made Easy with Excel Power ToolsExcel Data Analysis Basics = E-DAB
2. E-DAB-01: Introduction to Class. What is Data Analysis?InstructorScope of ClassVersion of ExcelDefine Data Analysis & Business IntelligenceGoals of ClassVideos Topics Presented In ClassFiles for you to DownloadWhat You Will Gain After Taking This Class
3. Instructor: Mike GirvinHighline College InstructorMicrosoft Excel MVP 2013-presentexcelisfun YouTube Channel 2008 – present+3000 Video, +100 classes/playlists
4. Scope of ClassIntroduction to Data AnalysisFor People With No Experiences With Data AnalysisLearn how to turn data into useful information and insightPre-Requisite for the Advanced Data Analysis class here at the excelisfun YouTube Channel: MSPTDA
5. Version of ExcelWhat Version of Excel:Excel Office 365What Version of Power BI Desktop:Free Download
6. Define Data Analysis & Business IntelligenceData Analysis:Convert Data into Useful Information for Decision MakersBusiness Intelligence:Convert Data into Useful/Actionable/Refreshable Information for Decision Makers in a Business SituationThe Business is Intelligent because it is making decisions based on Data!Both Help To:See Trends & PatternsAnswer Questions & Gain InsightShort Definition for both:Data Information
7. Goal of Data Analysis and Business IntelligenceCreate useful, updateable, actionable information for decision makers in the form of reports, visualizations and dashboards.
8. Goal of Data Analysis and Business IntelligenceCreate useful, updateable, actionable information for decision makers in the form of reports, visualizations and dashboards.
9. Goals of ClassIntroduction to these Excel Power Categories:Excel Spreadsheet Formulas & FeaturesStandard PivotTablesPower Query (in both Excel and Power BI Desktop)Data Model PivotTables using Excel Power PivotData Model Visualizations using Power BI Desktop
10. Goals of ClassIntroduction to these Specific Data Analysis Power Tools in Excel Office 365:SortFilterExcel Table FeatureSpreadsheet Functions like: SUMIFS, COUNTIFS and AVERAGEIFSOffice 365 Dynamic ArraysStandard PivotTables & SlicersCharts & VisualizationsPower QueryVLOOKUP Spreadsheet FunctionRelationship FeaturePower Pivot Data ModelDAX Functions like: SUMX, AVERAGEX, RELATED and COUNTROWSPower BI Desktop
11. Goals of ClassIntroduction to Data Analysis Terms and Processes, such as:DataProper Data SetDelimiterRelationshipsETLData ModelColumnar DatabaseDashboardMore…
12. Goals of ClassPerform these Data Analysis Steps:Import DataClean & Transform DataBuild Data ModelBuild Reports, Visualizations and Dashboards that Deliver Useful InformationWhen New Data Arrives, Refresh InformationAssess Usefulness of InformationRepeat Earlier Steps
13. Videos Topics Presented In ClassE-DAB-01: Introduction to Class. What is Data Analysis?E-DAB-02: Data, Proper Data Sets, Excel Tables, Sorting, Filtering & Logical TestsE-DAB-03: Summary Reports with Excel Spreadsheet FormulasE-DAB-04: Summary Reports with Standard PivotTables & SlicersE-DAB-05: Visualizations: Tables, Charts, Conditional Formatting & DashboardsE-DAB-06: Clean, Transform & Import Data with Power QueryE-DAB-07: VLOOKUP Spreadsheet Function to create a Worksheet Data ModelE-DAB-08: Relationship Feature to Create Power Pivot Data ModelE-DAB-09: Power Query & Power Pivot for Big DataE-DAB-10: Power BI DesktopE-DAB-11: Excel & Power BI Together
14. Final Video Titles:E-DAB 1: What is Data Analysis & Business Intelligence?E-DAB 2: Data, Proper Data Sets, Excel Tables, Logical Tests, MoreE-DAB 3: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays?E-DAB 4: PivotTables & Slicers to Create Dashboards & Summary ReportsE-DAB 5: Visualizing Data w Tables, Charts, Formatting & DashboardsE-DAB 6: The Magic of Power Query to Import, Transform & Load DataE-DAB 7: Data Modeling: Excel Formulas, Power Query, Power Pivot?E-DAB 8: Power Pivot: Big Data, Data Modeling, DAX & DashboardE-DAB 9: Power BI: Interactive VisualizationsE-DAB 10: Excel & Power BI Together to create Combined, Sharable Dashboards
15. Downloadable Files and Practice ProblemsExcel FilesPower BI FilesSource Data FilesPractice ProblemsPdf Notes from Class Video
16. What You Will Gain After Taking This ClassHave experience with all the Power Tools in Excel used for Data Analysis.Be able to take data and convert it into refreshable reports, visualizations and dashboards that can be used for decision making.Have the introductory level skills to move on to the more advanced Data Analysis and Business Intelligences classes taught for free at YouTube my Mike “excelisfun” Girvin:Excel Basics (Calculations & Data Analysis)Highline College Advanced ExcelHighline College BI 348 Microsoft Power Tools for Data AnalysisDynamic Array Playlist
17. Links to other classesFull excelisfun Channel at YouTube:https://www.youtube.com/user/excelisfunExcel Basics (Calculations & Data Analysis)https://www.youtube.com/playlist?list=PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1kHighline College Advanced Excelhttps://www.youtube.com/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKwHighline College BI 348 Microsoft Power Tools for Data Analysishttps://www.youtube.com/playlist?list=PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1Dynamic Array Playlisthttps://www.youtube.com/playlist?list=PLrRPvpgDmw0nwgWhZjKjqnAwfZBxLcsxx