Daily Data Tips - Android App & Website

A Flutter mobile application that provides daily data analysis tips for Excel, SQL, and Python libraries, along with a modern landing page website. Perfect for data analysts who want to learn something new every day!

📱 Android App Features

Phase 1 (Current)

• Daily Tip: Shows a different tip each day based on the current date
• Library Browsing: Browse tips by Excel, SQL, or Python (Pandas)
• Category Filtering: Filter tips by categories like "Math & Aggregate", "Data Preview", etc.
• Tip Details: Detailed view with code examples, descriptions, and reference links
• Search Functionality: Search through all tips by method name, description, or example
• Responsive Design: Clean, modern UI with light/dark mode support

Phase 2 (In Progress)

• Settings: Theme mode (System/Light/Dark)
• Notifications: Daily reminder toggle + time (UI wired; scheduling next)
• Privacy: Anonymous analytics toggle
• About & Support: App info, support email, contributor link

Future Phases

• Favorites System: Save and manage favorite tips
• Learning Progress: Track which tips you've learned
• Offline Mode: Full functionality without internet connection
• Export/Share: Share tips with colleagues

🌐 Website Landing Page

Modern Design Features

• Tailwind CSS: Modern, responsive design with beautiful gradients
• Mobile-First: Optimized for all screen sizes and devices
• Interactive Elements: Hover effects, smooth animations, and transitions
• Professional Layout: Clean typography and color-coded sections

Website Sections

1. Hero Section: Eye-catching header with app logo and main value proposition
2. Features Grid: 6 key features with icons and descriptions
3. Screenshots Gallery: Displays all 7 app screenshots with hover effects
4. Stats Section: Highlights impressive numbers (677+ tips, 3 libraries, etc.)
5. Download Section: Call-to-action with Google Play Store badge
6. Footer: Personal story, contributor link, and legal pages

Technical Features

• Responsive Design: Works perfectly on desktop, tablet, and mobile
• Smooth Scrolling: Navigation between sections with smooth animations
• Mobile Menu: Hamburger menu for mobile navigation
• Scroll Animations: Elements fade in as they come into view
• SEO Optimized: Proper meta tags and semantic HTML

🏗️ Project Structure

daily_data_tips_website/
├── index.html                    # Main landing page
├── pages/                        # Additional pages
│   ├── privacy-policy.html      # Privacy policy page
│   └── terms-of-service.html    # Terms of service page
├── assets/                       # Static assets
│   ├── images/                  # Images and media
│   │   ├── logo.svg            # App logo
│   │   └── snapshot/           # App screenshots
│   │       ├── 1.jpg
│   │       ├── 2.jpg
│   │       ├── 3.jpg
│   │       ├── 4.jpg
│   │       ├── 5.jpg
│   │       ├── 6.jpg
│   │       └── 7.jpg
│   ├── css/                     # Stylesheets
│   │   └── main.css            # Main stylesheet
│   └── js/                      # JavaScript files
│       └── main.js             # Main JavaScript file
├── LICENSE                      # MIT License
└── README.md                    # This file

android_app/                     # Flutter Android app (separate repository)
├── lib/                         # Flutter app source code
│   ├── models/                 # Data models (Tip, Category)
│   ├── services/               # Business logic (TipService)
│   ├── screens/                # UI screens (Home, Detail, Category)
│   ├── widgets/                # Reusable UI components
│   ├── utils/                  # Utilities (Theme, Constants)
│   └── main.dart               # App entry point
└── assets/
    └── data/                   # JSON data files
        ├── excel_tips.json
        ├── sql_tips.json
        └── library_tips.json

🚀 Getting Started

Website Setup

1. Clone the repository:

   git clone <your-repo-url>
   cd daily_data_tips_website

2. Open in browser:

   # Simply open index.html in any modern web browser
   open index.html

3. Local server (recommended for development):

   # Using Python
   python -m http.server 8000
   
   # Using Node.js
   npx serve .
   
   # Using PHP
   php -S localhost:8000

Project Structure Benefits

• Organized Assets: All images, styles, and scripts are properly organized
• Maintainable Code: Separated CSS and JavaScript for easier maintenance
• Scalable: Easy to add new pages, styles, or functionality
• Performance: Optimized asset loading and caching
• SEO Friendly: Proper file structure and semantic HTML

Android App Setup

1. Prerequisites:

   • Flutter SDK: Install from flutter.dev
   • Android Studio or VS Code
   • Android Device or Emulator

2. Installation:

   cd android_app
   flutter pub get
   flutter packages pub run build_runner build
   flutter run

📊 Data Structure

The app uses JSON files containing tips with the following structure:

{
  "id": "excel-sum",
  "library": "excel",
  "method": "SUM",
  "description": "Add numbers in a range.",
  "example": "=SUM(A1:A10)",
  "category": "math & aggregate",
  "difficulty": "beginner",
  "reference": "https://support.microsoft.com/en-us/office/sum-function-",
  "notes": "Generated tip"
}

Supported Libraries

• Excel: 127+ tips covering formulas, functions, and features
• SQL: 50+ tips covering queries, joins, and database operations
• Python (Pandas): 500+ tips covering data manipulation and analysis

Categories

• Excel: Math & Aggregate, Lookup & Reference, Dynamic Arrays, Logical, Text, Date & Time, etc.
• SQL: Query, Join, Aggregation, Window Functions, DML, DDL, etc.
• Python: Data Preview, Summary, Filtering, Grouping, Reshaping, Merging, etc.

🎨 Design System

Color Scheme

• Primary: Blue (#2196F3)
• Excel: Green (#4CAF50)
• SQL: Blue (#2196F3)
• Python: Orange (#FF9800)
• Difficulty Levels: Green (Beginner), Orange (Intermediate), Red (Advanced)

Website Technologies

• HTML5: Semantic markup with proper structure
• Tailwind CSS: Utility-first CSS framework
• Custom CSS: Additional styles and animations in assets/css/main.css
• Vanilla JavaScript: Interactive features and animations in assets/js/main.js
• Font Awesome: Icons
• Responsive Design: Mobile-first approach with proper breakpoints

🔧 Development

Website Development

• No build process required - Pure HTML/CSS/JS
• Organized structure - Separate directories for assets, styles, and scripts
• Responsive design - Mobile-first approach with proper breakpoints
• Modern CSS - Flexbox, Grid, and CSS animations
• Vanilla JavaScript - No frameworks, lightweight and fast
• Modular code - Separated CSS and JS for better maintainability

Android App Development

• Flutter: Cross-platform mobile development
• Provider: State management
• SQFlite: Local database
• Shared Preferences: Simple key-value storage
• URL Launcher: Open external links

Key Dependencies

• provider: State management
• sqflite: Local database
• shared_preferences: Simple key-value storage
• url_launcher: Open external links
• flutter_markdown: Display formatted text
• json_annotation: JSON serialization

🧪 Testing

Website Testing

1. Cross-browser testing: Chrome, Firefox, Safari, Edge
2. Responsive testing: Various screen sizes
3. Performance testing: Page load speed and animations
4. Accessibility testing: Screen readers and keyboard navigation

Android App Testing

1. Data Loading: Verify all tips load correctly
2. Navigation: Test all screen transitions
3. Search: Test search functionality with various queries
4. Categories: Test category filtering
5. Daily Tips: Verify daily tip changes each day

📱 Screenshots

The website includes 7 app screenshots showcasing:

• Home screen with daily tip
• Category browsing
• Search functionality
• Tip details with examples
• Settings and preferences
• Dark mode interface
• Responsive design

🤝 Contributing

How to Contribute

1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Test thoroughly
5. Submit a pull request

Contributor Form

Interested in contributing? Fill out our contributor form: Be a Contributor to this Android App

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🆘 Support

If you encounter any issues or have questions:

1. Check the existing issues on GitHub
2. Create a new issue with detailed information
3. Contact: developerkunalbandale@gmail.com

🗺️ Roadmap

Website Enhancements

• Add more interactive animations
• Implement dark mode toggle
• Add blog section for tips
• Create user testimonials section
• Add analytics tracking

Android App Roadmap

• Favorites system with local storage
• Learning progress tracking
• Improved search with filters
• Tip sharing functionality
• User preferences
• Push notifications
• Offline mode
• Data export

💡 The Story Behind Daily Data Tips

As a fresher, I struggled to remember all the functions and methods from different Python libraries like NumPy, Pandas, and Scikit-learn. So I decided to gamify this learning process by creating daily random tips that help freshers stay sharp and learn something new every day!

The app started as a personal project to solve my own learning challenges, but I realized it could help many other developers facing the same struggles. That's how Daily Data Tips was born - to make data analysis learning fun, engaging, and accessible to everyone.

---

Happy Learning! 📚✨

Made with ❤️ for the data analysis community