Add reporting and analytics to mysql data in 10 minutes
Download
1 / 12

Add Reporting and Analytics to MySQL Data in 10 minutes - PowerPoint PPT Presentation


  • 95 Views
  • Uploaded on
  • Presentation posted in: General

Add Reporting and Analytics to MySQL Data in 10 minutes. Journey from self-service to managed BI Rushabh Mehta, Mentor and Managing Director (India) Solid Quality Mentors www.solidq.com. Goals. Simplified data mash-up and analysis Extended Reporting Managed BI Goal #1 – BI in 10 minutes!.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

Download Presentation

Add Reporting and Analytics to MySQL Data in 10 minutes

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Add reporting and analytics to mysql data in 10 minutes

Add Reporting and Analytics to MySQL Data in 10 minutes

  • Journey from self-service to managed BI

  • Rushabh Mehta, Mentor and Managing Director (India)

  • Solid Quality Mentors

  • www.solidq.com


Goals

Goals

  • Simplified data mash-up and analysis

  • Extended Reporting

  • Managed BI

  • Goal #1 – BI in 10 minutes!


Sales data dimensional model

Sales Data Dimensional Model


Considerations

Considerations

  • Sales data processed into a Relational Dimensional Model

  • Data Cleansing already done as part of loading Model

  • Using MyISAM storage for rapid reporting


Add reporting and analytics to mysql data in 10 minutes

DEMO

  • Analyzing MySQL data


Technologies used

Technologies Used

  • On Network

    • Data Sources

      • MySQL Database (Release 5.1.45) – Sales data

      • ATOM Data Feeds

  • On Client Machine [The Information Worker]

    • Data Sources

      • Text File

      • Excel

    • Drivers

      • MySQL Connector-ODBC 5.1.6 – DSN created to MySQL database

    • Data manipulation, model creation and analysis technologies

      • Excel 2010

      • PowerPivot Add-in for Excel 2010


Add reporting and analytics to mysql data in 10 minutes

DEMO

  • Extended Reporting

  • Reports against Analytical Model

  • Reports against MySQL


Technologies used1

Technologies Used

  • On Network

    • Microsoft SharePoint Server 2010

      • Excel Services, PowerPivot Service, Analysis Services and Reporting Services

      • MySQL Connector-ODBC 5.1.6 and DSN

  • On Developer Machine [The Report Creator]

    • Business Intelligence Development Studio

    • MySQL Connector-ODBC 5.1.6 and DSN

  • On Client Machine [The Information Worker or Report Consumer]

    • Internet Explorer

    • .NET Framework


  • Add reporting and analytics to mysql data in 10 minutes

    DEMO

    • Managed BI Solution

    • Managed Analytical Model


    Technologies used2

    Technologies Used

    • On Network

      • MySQL Database

        • Sales Database

      • SQL Server 2008 R2

        • Analysis Services and Database Engine (additional data)

        • MySQL ADO.NET Provider

  • On Developer Machine [The Model Creator]

    • Business Intelligence Development Studio

    • MySQL ADO.NET Provider

  • On Client Machine [The Information Worker or Information Consumer]

    • Excel

    • Other client tools for OLAP


  • References

    References

    • Technology References

      • www.powerpivot.com

      • www.microsoft.com/BI

      • www.sqlpass.org (Free 300+ Hours of deep technical recorded content)

    • Upcoming Free Educational Series

      • 24 Hours of PASS R2 (http://www.sqlpass.org/24hours/2010/)

    • Implementation and Training

      • www.solidq.com

    • Emails

      • Info @ solidq.com

      • Rmehta @ solidq.com


    Thank you

    THANK YOU


    ad
  • Login