Banner Image

All Services

Other

Data Analysis and Visualization

$8/hr Starting at $25

I have just completed last September the Course: DAT206X: Analyzing and Visualizing Data with Excel. An online learning initiative of Microsoft Corporation through edX. I received a Certificate of Completion -- edX Verified Certificate of Achievement Issued last September 15, 2017. Verified Certificate ID -- 2f90d12fa7b047f98e0aa37607bdb6c7 Performing data analysis in Excel using classic tools, such as pivot tables, pivot charts, and slicers, on data that is already in a worksheet / grid data. Exploring an Excel data model, its content, and its structure, using the Power Pivot add-in. Creating DAX expressions for calculated columns and measures. Learning how to use Power Query, and building an Excel data model from a single flat table. Importing multiple tables from a SQL database, and creating an Excel data model from the imported data. Creating a mash-up between data from text-files and data from a SQL database. Getting the details on how to create measures to calculate for each cell, filter context for calculation, and explore several advanced DAX functions. Finding out how to use advanced text query to import data from a formatted Excel report. Performing queries beyond the standard user interface. Exploring ways to create stunning visualizations in Excel. Using the cube functions to perform year-over-year comparisons. Creating timelines, hierarchies, and slicers to enhance the Power BI service. Exploring the use of Excel on the mobile platform.

About

$8/hr Ongoing

Download Resume

I have just completed last September the Course: DAT206X: Analyzing and Visualizing Data with Excel. An online learning initiative of Microsoft Corporation through edX. I received a Certificate of Completion -- edX Verified Certificate of Achievement Issued last September 15, 2017. Verified Certificate ID -- 2f90d12fa7b047f98e0aa37607bdb6c7 Performing data analysis in Excel using classic tools, such as pivot tables, pivot charts, and slicers, on data that is already in a worksheet / grid data. Exploring an Excel data model, its content, and its structure, using the Power Pivot add-in. Creating DAX expressions for calculated columns and measures. Learning how to use Power Query, and building an Excel data model from a single flat table. Importing multiple tables from a SQL database, and creating an Excel data model from the imported data. Creating a mash-up between data from text-files and data from a SQL database. Getting the details on how to create measures to calculate for each cell, filter context for calculation, and explore several advanced DAX functions. Finding out how to use advanced text query to import data from a formatted Excel report. Performing queries beyond the standard user interface. Exploring ways to create stunning visualizations in Excel. Using the cube functions to perform year-over-year comparisons. Creating timelines, hierarchies, and slicers to enhance the Power BI service. Exploring the use of Excel on the mobile platform.

Skills & Expertise

Admin SupportAnalyticsCreativeData AnalysisData ManagementForecastingIdentity PackagesImport/Export OperationsInternal ControlLayout DesignLearningMicrosoft ExcelMicrosoft Excel Pivot TablesMobile DevelopmentModelingOracle Bi PublisherProject ManagementSQLStatistical AnalysisTable DesignTooling Design

0 Reviews

This Freelancer has not received any feedback.