Welcome
Welcome to my data analytics space.
This is a continually growing archive and collection of the fundamental principles and processes I have learnt through my career in database administration and data analytics dashboard development. A lot of the information is critical to the success of any project or team. I have also developed some very useful scripts and tools to help me in my career, you are welcome to use any scripts and tools I have developed for free and are more than welcome to adapt and modify them to whatever needs you have.
1. Guidelines
- 1.1 Foundation Principles
- 1.2 Business Intelligence and Data Analytics
- 1.3 Databases
- 1.4 Development Operations (DevOps)
2. Business Intelligence Tools
- 2.1 Power BI
- 2.2 Qlik / QlikView / QlikSense
- 2.3 Spotfire
- 2.3.1 Spotfire Server Setup and Administration
- 2.3.2 Spotfire Training and Education
- 2.3.3 Spotfire Dashboard Development
- Spotfire - Embed web player frame in another website
- Spotfire HTML / Jquery / Javascript Scripts
- Spotfire IronPython / R / TERR Scripts
- Spotfire IronPython - Apply custom colour scheme / palette
- Spotfire IronPython - Apply document property to filter
- Spotfire IronPython - Change language
- Spotfire IronPython - Export (Analyst client only)
- Spotfire IronPython - Reset filters and marking
- Spotfire R - Trigger IronPython Script on filter/marking change
- 2.4 Tableau
3. Databases and ETL
- 3.01 Office 365
- 3.02 Azure Portal
- 3.03 Microsoft SQL
- 3.3.1 Install Guide for Microsoft SQL Server
- 3.3.2 SQL Server Database Engine
- Bulk Import Image File Data into SQL Server Table
- Calendar Reference Table
- Database Administration Scripts / Tools
- Database Audit Scripts / Tools
- Determine Data Types from Query
- Import Blob Storage CSV File to Azure SQL Server Table
- Optimised Queries for Microsoft SQL Server for BI Dashboards
- Scheduled Stored Procedures and Log Setup
- SQL Server Analysis Services Linked Server
- Stored Procedure Error Handling
- Stored Procedures and Functions for Web Based APIs
- 3.3.3 SQL Server Analysis Services (SSAS)
- 3.3.4 SQL Server Reporting Services (SSRS)
- 3.3.5 SQL Server Integration Services (SSIS)
- 3.04 MySQL
- 3.05 Oracle
- 3.06 Microsoft Windows
- 3.07 Internet of Things (IoT)
- 3.08 Snowflake
- 3.09 Python
- 3.10 Alteryx
4. Development Operations and Version Control
- 4.1 Azure DevOps
- 4.1.1 Azure DevOps Server Setup and Administration
- 4.1.2 Azure DevOps Training Videos
- 4.1.3 Using Azure DevOps
- 4.1.3.1 Organisation or collection settings
- 4.1.3.2 Project settings
- 4.1.3.3 Overview
- 4.1.3.4 Boards
- Azure DevOps - Adding or editing columns or vertical swim lanes
- Azure DevOps - Custom tags for work item tracking
- Azure DevOps - Editing the Work Item card layout
- Azure DevOps - Linking the repository to the User Story
- Azure DevOps - Queries
- Azure DevOps - Shared Steps Work Item for dashboard testing
- Azure DevOps - Sprints
- 4.1.3.5 Repos
- 4.1.3.6 Pipelines
- 4.1.3.7 Test Plans
- 4.1.4 Glossary
- 4.2 Visual Studio