Watch the full video

The m-Power Demo Video Series:
How to create a custom BI/Reporting suite (with write-back and data warehousing)

The m-Power Demo Video Series takes you on a deep dive into m-Power's build process, walking you through a start-to-finish development project. In every video, we tackle a development project that would require days/weeks of manual coding, and complete the whole thing in under 2 hours.

In this video, we walk you through a custom business intelligence/reporting project. We start with a single spreadsheet full of data and create a suite of BI & reporting applications that includes features like multi-tenant security, forecasting, dashboarding, data write-back, data warehousing, and many more. This video walks you through the project from start to finish, and explains each step along the way.

Step-by-Step Videos


Part 1: Introduction

In part 1 of this video series, we introduce you to the m-Power Development Platform and explain the custom BI/reporting suite we're about to create.


Part 2: Demo

In part 2 of this video series, we walk you through the business intelligence and reporting applications we're going to create in the project.


Part 3: Spreadsheet Upload

In part 3 of this video series, we upload a spreadsheet full of data into m-Power and turn it into a database table. In the rest of the series, we'll be building a suite of applications over this data.


Part 4: Building the order search application

In part 4 of this video series, we build our first application over our new database table. This application displays order data and lets users sort, search, and filter through that data.


Part 5: Customizing the order search application

In part 5 of this video series, we customize the application we just created. We add a customer dropdown list and features that let users reorder columns and export data to Excel.


Part 6: Application Security

In part 6 of this video series, we add user security to the application. This places the application behind a login screen, and limits application access to specific users.


Part 7: Multi-tenant Security

In part 7 of this video series, add multi-tenant security to the application. This secures the application at the row level, meaning different users can access the same application yet only see the data they're authorized to view.


Part 8: Creating the Pivot Table

In part 8 of this video series, we create a web-based pivot table report over our data. The pivot table lets our users filter, sort, and analyze data from many different angles.


Part 9: The Ranking Report

In part 9 of this video series, we create a ranking report over our data. The ranking report lets users generate top/bottom lists over any aspect of their data.


Part 10: The Application Menu

In part 10 of this video series, we create a menu for our applications. The menu provides our users with a simple way to access all of the applications we're creating.


Part 11: The Period Analysis Application

In part 11 of this video series, we create the period analysis application over our data. The period analysis application lets users compare data across date ranges. For instance, it's often used to compare monthly performance vs. the same month in the prior year.


Part 12: Making a Responsive Graph

In part 12 of this video series, we customize the graph in our period analysis application. We'll customize the look/feel and make the graph responsive, so it adapts to any screen size.


Part 13: Building the Dashboard

In part 13 of this video series, we create a business dashboard with m-Power. We'll take charts and tables from other applications we've already created and combine them into a dashboard.


Part 14: Adding a Dropdown List

In part 14 of this video series, we add a dropdown list to our dashboard. This dropdown list lets users easily filter the dashboard data by individual customers.


Part 15: Customizing the Application Menu

In part 15 of this video series, we customize the application menu that we created in part 10. We'll change the menu from a text-based layout to a more graphical, card-based layout.


Part 16: Forecasting Application Demo

In part 16 of this video series, we explore the forecasting application that we'll be creating. This application lets users compare actual sales data with forecast sales data.


Part 17: Building the Data Upload Application

In part 17 of this video series, we create a data upload application. The data upload application lets users upload forecast data to the database so it can be used in the forecasting application.


Part 18: Building the Data Warehouse

In part 18 of this video series, we create a data warehouse for our forecasting application. We need this data warehouse because the data we're comparing in the application is formatted differently. The data warehouse object takes data from one table and summarizes it into a like format.


Part 19: Automating the Data Warehouse

In part 19 of this video series, we automate the data warehouse that we created in the last video. This automation will run on a nightly basis and update our data warehouse with new data.


Part 20: Loading the Month Table

In part 20 of this video series, we load a month table to our project. We'll use this table to convert numeric months into text within our applications.


Part 21: Sales Forecasting Application Development

In part 21 of this video series, we create the sales forecasting application. This application lets users easily compare sales data with forecast data and gauge performance vs. expected performance.


Part 22: Customizing the Forecast Application

In part 22 of this video series, we customize the sales vs. forecasting application that we just created. We'll use m-Power's visual editor - m-Painter - to update the look/feel of our application and add color coding.


Part 23: Building a Write-Back Application

In part 23 of this video series, we create an application to maintain forecast data. This application offers database write-back capabilities, and lets users update forecast data in the database. In the rest of the series, we'll be building a suite of applications over this data.


Part 24: Conclusion

In part 24 of this video series, we wrap up the project. We'll recap what we've built and show you how to learn more. Overall, we completed the entire project in about an hour and half using m-Power.

Testimonials

Learn how m-Power can help you